package sopia.conn;

public class SQLQuery {
	//Account
    public static final String KEY_NAME_ACCOUNT = "nameAccount";
    public static final String KEY_AMOUNT_ACCOUNT = "amountAccount";  
    public static final String KEY_CURRENCY_ACCOUNT = "currency";
    //Category
    public static final String KEY_NAME_CATEGORY = "nameCategory";
    //Expense
    public static final String KEY_TYPENAME_EXP = "typeNameExp";
    public static final String KEY_NAME_CATEGORY_EXP = "nameCategoryExp";
    public static final String KEY_AMOUNT_EXP = "amountExp";
    //Item Expense
    public static final String KEY_NAME_ITEMEXP = "nameItemExp";
    public static final String KEY_TYPENAME_ITEMEXP = "typeNameExpItemExp";
    public static final String KEY_AMOUNT_ITEMEXP = "amountItemExp";
    public static final String KEY_DATE_ITEMEXP = "dateItemExp";
    public static final String KEY_COMMENT_ITEMEXP = "commentItemExp";
    public static final String KEY_NAMEACCOUNT_ITEMEXP = "nameAccountItemExp";
    
    
    public static final String TAG = "DBAdapter";
    
    public static final String DATABASE_NAME = "Budget";
    
    public static final String DB_ACCOUNT_TABLE = "Account";
    public static final String DB_EXPENSE_TABLE = "Expense";
    public static final String DB_CATEG0RY_TABLE = "Category";
    public static final String DB_ITEM_EXPENSE_TABLE = "ItemExpense";
    
    public static final int DATABASE_VERSION = 1;
    
//	public static final String SQL_CREATE_ACCOUNT_TABLE =
//            "create table Account (_id integer primary key autoincrement, "
//            + "accountName text not null, amount text not null);";
	public static final String SQL_CREATE_ACCOUNT_TABLE = 
        " CREATE TABLE Account (nameAccount text NOT NULL PRIMARY KEY UNIQUE, " +
        "amountAccount double NOT NULL, currency text NOT NULL);";
	public static final String SQL_CREATE_EXPENSE_TABLE = 
        " CREATE TABLE Expense (typeNameExp text NOT NULL,nameAccount text NOT NULL, " +
        "nameCategoryExp text NOT NULL,amountExp double NOT NULL, " +
        "PRIMARY KEY (typeNameExp,nameAccount));";
	public static final String SQL_CREATE_CATEGORY_TABLE = 
        " CREATE TABLE Category (nameCategory text NOT NULL PRIMARY KEY);";
	public static final String SQL_CREATE_ITEM_EXPENSE_TABLE = 
        " CREATE TABLE ItemExpense (nameItemExp text NOT NULL , " +
        "typeNameExpItemExp text NOT NULL,amountItemExp double NOT NULL, " +
        "dateItemExp date NOT NULL,commentItemExp text NOT NULL,nameAccountItemExp text NOT NULL);";
}
